Batch Job/Schedule (Available only in Full Version)

Navicat allows you to create a batch job for setting schedule to execute at one regular interval. Batch job can be created for Query, Data Transfer, Data Synchronization, Import and Export from MySQL, Oracle, PostgreSQL, SQLite and SQL Server. You can define a list of actions to be performed within one batch job, either run it manually or at the specified time/periodically.

Just simply click to open an object pane for Schedule. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit, open and delete the selected batch job/schedule.

Create Batch Job

To create a new batch job

To create a new batch job with modification as one of the existing batch jobs

To duplicate an existing batch job

Edit Batch Job

To edit the existing batch job

To change the name of the batch job

Run Batch Job

To run a batch job

To run from Command Line

Delete Batch Job

To delete a batch job

Convert Batch Job

To convert a batch job

Set Schedule

To set schedule to the batch job

Hint: CmdLineJob.log stores all the operations executed, indicating success or failure during the schedule.

To show all set schedules

Delete Schedule

To delete a schedule